I am, on the whole, in favor of it for reasons that have nothing much to do with Scotland. Both the right of secession and smaller countries strike me as good things. The one big exception is that countries often put up trade barriers against each other, and big markets are better than small.
That exception vanishes for small countries that are part of the European Union, since it provides them access to a large free trade area. So the critical question for a region of a member state considering secession is whether the E.U. will let it in. Given that the U.K. has made it reasonably clear that if it loses the vote it will accept the outcome, I think it is almost certain that an independent Scotland will be permitted to become a member of the union.
A precedent that will matter to the inhabitants of Catalonia, Brittany, northern Italy, any region where there is significant pressure for independence.