In the end, in a democratic society, it should be the majority will of the people that prevails.
Whether the other countries in the Union should have a vote is a different matter.In a business partnership, partners can leave without asking the other partners if they are allowed to.
It is interesting to note that in any debate of this nature, it is England that is singled out as the other party involved, when the Union consists of more than just Scotland and England. Because England has by far the bigger population it is perceived as some kind of villain. Why should this be?
The average English person is very similar to Scottish, Welsh and Irish in their outlooks and aspirations.
What I don’t like is the “wha’s like us” attitude, and the call for independence based on nationalist rhetoric and xenophobia rather than on informed judgement.
I personally cringe when I hear that dirge “Flower of Scotland” sung to an audience consisting predominantly of English tourists. I find it embarrassing and humiliating.
How many of the Scottish electorate would be able to give a yes or no answer to the independence question based on an informed and rational judgement? The whole thing is more complex than that, and we would need to know what the “business plan” was for the coming x number of years, and be able to assess whether it is realistic when looked at objectively. We are unlikely to get anything like this from politicians.
Having said all of that, I would also say that there has surely been something wrong with the management of this country, Scotland. We led the world in the days of the Scottish Enlightenment, and have made a contribution to the world that far outweighs our size and population. Why has our country not benefited more from this contribution? (or is that an example of “wha’s like us”?)

Merda taurorum animas conturbit. Quidquid latine dictum sit, altum videtur