Kiln Park is in Tenby and has access to one of the excellent beaches, it a "all singing and dancing" park ie pools, entertainment, restaurants, amusements etc....
Alternatively, there is Tudorglen Park, between Tenby and Pembroke, is smaller site but it does have it's own pool