Beautiful city is one of UK's friendliest and has 'world's prettiest street'