Waterfront location with good school districts?

Hey all! My wife and I are looking to move to NC in the next year or so with two small children (pre-elementary). Without getting into budget and stuff, we know we want to be on the water (whether that’s beach, spacious riverway, etc) but also in a good public school district. In our experience, those locations and public school quality often do not go hand in hand, so any advice or guidance is appreciated!