'Friendly' and 'walkable' city named one of the best UK destinations