Quirky city 'straight out of Harry Potter' is the friendliest place in the UK