A Welsh caravan site next to a sandy beach and praised for its "magnificent views" has been named the best in the UK by a ...