Poe's Tavern on Sullivans Island
Blind Tiger Downtown
Two of my favs
Also, the haunted night tour is good for a spot of history, and as lame as it seems, the horse carriage tour during the day is both a good way to beat the heat and see some really cool stuff (houses, historical places, etc)...