A Which? survey has revealed the worst UK towns for a short break, with one Scottish destination landing at the bottom