'Friendliest place in the UK' where 'locals go out their way to be friendly'