Hove is the happiest place to live in Brighton and Hove and in England, a new survey has found.