I'm not from the UK/Scotland, so I don't really have an opinion about what they should do.
But from what I've heard so far, personally I reckon it will be a 'No'. Close or not, I think that most people who decide at the last moment probably are more likely to vote No. I just don't see it happen.