A beautiful Welsh destination on the Pembrokeshire coast has been named one of the best places in the UK to spend 48 hours