Multiple launch/takeout sites. You can find here:
https://raleighnc.gov/river-access
Water level can be found here:
https://waterdata.usgs.gov/monitorin...060&period=P7D
Switch readout to "discharge". Starting at falls dam, you can run it at the current level of 170 cfs, low but doable in a canoe. Optimal level is 300-600 cfs. You can run it much higher as well (2000-3000 cfs), but water will start getting very pushy if you are not experienced with whitewater paddling.
Milburnie dam to poole road is a nice short section, with new rapids since the removal of the dam. Bike path runs from falls dam to poole rd, so you can scout entire length of river to see what looks good to you.