This 'colourful town' that is known for its 'spectacular' views has been named the happiest place to live in Scotland.