The North Yorkshire spa town of Harrogate has won the title of “happiest place to live in Britain”, according to a new survey.