A ‘no’ wouldn’t surprise me. Anyway, even if ‘yes’ i’d imagine Scotland will be part of the ‘Commonwealth Realms’ (unless they opt for a republic), with its own PM but the queen will remain as the Queen of Scotland. Actually if am not mistaken, HM has more Scottish blood than many other British monarchs - her mother came from an ancient aristocratic Scottish family.
No I don’t think she will be Queen of Scotland if they get a ‘yes’ to succeed.