If you want to take the kids to fish off the piers the Palace drive on pier was good last week, caught white trout till we did'nt want any more and my son got a little red( inch or so too short) they were biting best on free lined shrimp and as small a split shot as it took to keep it down, this was out on the end....if you want to catch some sheepshead try the middle of the pier at the first turn around...carolina rigged live or fresh shrimp as close to the structure as you can get it, the trick on them is to keep picking your bait up slightly and moving it a foot or so every couple of minutes, you'll catch most of em when you go to move it.
Then there is the D'iberville marina pier under 110...the water is deep out on the end and holds some nice black drum, fun for kids to catch...i catch most of em here on a half crab. Back close in flounders can be found with a carolina rigged bull minnow and croakers and ground mullet(not to mention hardheads)on shrimp.