A “gorgeous” North East seaside town with “stunning” views has been ranked the third happiest place to live in the UK.