Unless mistaken, you won't get a site right on the beach with a pub. Your best bet might be Saundersfoot. I think Newport does have a couple of sites near the beach, it's a lovely area, but not a lot to do unless you get beach weather. You need to be able to speak Welsh in north Pembrokeshire though.
Anne
Don't forget to leave a review of the campsites you have visited this year or last!