The official SNP policy is for the monarchy to remain unchanged though if independence came about I suspect it wouldn't take too long for that issue to be at least looked at to see if there was enough support for a republic in Scotland at large. There probably isn't at the moment. I don't think they'd be likely to dump the monarchy within this monarch's lifetime though. If they did it would be for a republic though rather than them choosing a new monarch.