Take 421 South until you run out of road. Drop your kayak and park. Excellent fishing along the rocks and throughout. Head directly across to Zekes Island. There's a small beach where you can take a rest, explore, have a snack. Back on the water, follow the grass line and you come across several great places to fish. Very few boats out here. Great for kayaks!
Another spot is Snows Cut boat ramp but be prepared for a lot of boat traffic.
Lastly, Carolina Beach State Park marina. Just off the beach on the CF River south is a artificial Reef. It's outlined by buoys.
IMHO - These are listed in the order of best fishing spots.
Your results may vary.
There are many other areas but these are easy access and productive.