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