Ideally you want to be close to uptown as you can if you going to rely on the CATS bus system route. I think you might want to live is close to a bus route. Most of CATS buses head from transportation center in uptown to/from their desination a few run after midnight but not many at all. Far as your clubbing goes so keep that in mind that you may need Cab fare. Also you want your commute time to work minimal due to possible bus change overs. There usually about 15 minute layover in daytime hours or 30 minute layover at night depending on buses your transfering from and to.
There will be light rail transit line running in the south corridor parallel to south blvd so that may be ideal place to get but it will not be ready to November as it stands now. If your looking for an apartment look into the various ones off Sharon Road West as a option to consider but for now it a long bus ride due to all the stops between uptown and that location.
Ideally you might go for Dilworth a very fun section of charlotte with lots of character. It is minutes from uptown, and south park, and South End. Plus a great neighborhood area. In Dilworth it had cute shops great restaurants, near Freedom Park, and couple of coffee houses all within walking distance. Caribou Coffee always has a fun crowd at night. Salem Village is apartments that might work for you and there will be shuttle buses to the light rail in future from Dilworth. plus if you do end up taking a cab the rates will not be too extreme from this location.
Other than uptown Dilworth is a ideal central location to meet up with friends. Good Luck.