I believe you may be interested in the Charlotte Whitewater Centre. Check out http://www.usnwc.org/.
The course is one of the best man made facilities in the world. It is diverse, affordable and heaps of fun. It has all the river features your heart could desire. The website has all the opening hours, pictures and many other details of the whole venue. about 11 years ago