I think we ended up hanging out almost every night at Lonestar (near the hilton). Very laid back place with a lot of 'locals' hanging out there. (Well, they were all kanucks and aussies that happened to be working there) While you're there, grab a slice Gino's across the parking lot..... really good pizza, especially at 12:30am! The bartenders are partial to giving you free Jaeger shots!!!! yuck! I can handle hard liquor... but yeager makes my stomach turn
Rackem's was a cool location right on the water just at the edge of downtown next to hammerheads. The owner loves her jack daniels... so get ready to do lots of jack! That i can handle much better!
Fidel Murphy's was a nice irish bar, with good bar food (spicy conch fritters!), even had a dart board. Triple Crown was pretty good too... but quiet on the day we went.
As for the club scene.... we didn't really hit it, but all everyone ever talked about was Bed and O-Bar.
Anyway, you can't go wrong. If you are staying at the marriott resort, you can walk to several of the bars. Otherwise, take a cab or get someone to drive you... everythings pretty close by.