The Whitewater Center is awesome. Went to a wedding there one time. White water rafting, huge zip line, mountain biking, rock wall climbing, booze, usually live music. I highly recommend it.
Edit:
Epicenter in Uptown. Great for night life. Something for everyone. Watch a movie in a theatre while being served dinner and drinks, clubs, arcade, bowling alley....really fun place right down the street from the stadium.
http://epicentrenc.com