Durham has been listed among The Guardian's happiest places to live in Britain, topping the list of towns in the North.