Scottish city named UK's best spot for sustainable travellers