New research has revealed the UK's most accessible staycation spots - and this picturesque Pembrokeshire town in west Wales has come out on top.