The survey of Britain’s 1,250 towns has landed on the most beautiful and the ugliest in Scotland