Pawleys Island - have been going there since I was born, including last month. Guess the home will be just off the south causeway, down the road from the Food Lion. Hurricanes Hazel (1954) and Hugo (1989) did make a mess there but most houses on the mainland (your area) survived. As you have noted, substantial debris from the island could come across the marsh - but that would be a direct hit from at Category 4 or 5 storm.
As for timber piling lifetime - CCA treatment has been restricted for residential use, but should still be available for piling. Treatment with 0.6 lb/ft^3 is normally considered "permanent" - permanent being, say 50+ years (and probably a lot longer). If your have longevity concerns, consider going to CCA treatment of 2.5 lb/ft^3, differential cost would most likely be one or two thousand dollars for piling need for that size house. That level of treatment (2.5) is usually specified for continuous salt water exposure. For your application, pile useful lifetime should be several family generations.
For general information on pile lifetime and other issues, go to my website (link below) and download documents from my
"American Wood Preservers Institute" page. These old articles address creosoted pile, but in my opinion, CCA is just as good, or better - it has just not been in use long enough to have a century of experience behind it.
If you have specific questions, you can contact me thru the email at my website.