While Harrogate won the title of the happiest location to live in the UK, those living in London and the south east were found to be the least happy.