Here's something from the Herald. Now I realise the survey is a few years out of date and the sample size is rather small but I've not been able to find anything more recent.
From the link
"The divide in opinion on nuclear weapons on either side of the border is evidenced in a YouGov poll for the Times, where 56% of UK respondents want to replace Trident compared with 42% in Scotland.
Just 25% of UK respondents want it scrapped compared with 48% in Scotland, the poll of 1,656 adults on January 25 and 26 found.
When Scotland's 144 respondents are removed, support for Trident south of the border rises to around three-fifths while support for scrapping it falls further."
Its a tricky subject, I'm pretty sure if there was a vote Scotland wouldn't want it, it is a lot of money and it is chilling what these weapons can do, I'm not sure it's a good idea to be without them though.