The most beautiful village, town or city in the Scottish Lowlands has been named, and it's not the Georgian streets of Edinburgh or the seaside charm of St Andrews that's taking the crown