Trident would see out its life on the Clyde, of that I am sure. There are a lot of CND types up here voting Yes purely to get rid of it, but they've been had. Even the SNP White Paper on independence contains some very obvious weasel words about their aspirations to move it.
After that, Devonport is probably the most likely alternative site for the system that replaces Trident.
But it's not going to happen.