Well there are two places you can canoe or kayak . One is Magees Creek or Bogue Chitto River. The river is real easy, the creek is a little more for the experienced paddler. It's still not difficult, just many obstructions which to me is what makes it a great place to canoe.
The water is clear and flows but pretty calm, no whitewater. There are a couple places where the flow is a little faster which makes me wish the entire trip was like that. Not too many sandy beaches; mostly rocky and hard clay.
The creek is mostly quiet with some other paddlers present at times, however on my recent trip I went 6 miles and saw not one other person. That suited me just fine. There is lots of wildlife to see ... snakes, birds sometimes deer ... NO GATORS!
It really is a nice place to paddle, and the folks that run the local outfitter (Canoe and Trail Outpost) are super friendly. They offer shuttle service if you have your own boat; $15 for rental, 25 dollars for a short trip (about 6 miles), or 35 dollars for a long trip about 13 miles (that's on the creek). I never do the river trip... way too easy for me.
There are RV hook ups available (I do not know the cost), and there are primitive camp sites; hot showers are avaiable; ice too. They do have some nice cabins for rent but reservations are a must long in advance of your trip.
Canoe and Trail Outpost
They are near Tylertown, MS
Fees are stated above or see the Canoe and Trail Outpost website for more details
From New Orleans take the Causeway North to LA 25 on to state line (at LA/MS State Line, LA 25 changes to MS 27). Keep going North 2.1 miles past the State Line and turn left on Dillons Bridge Road - Go 1.1 miles down Dillons Bridge Road and Canoe and Trail Outpost is on the left.