Plenty of great options in the city centre, along the Nevsky Prospect and nearby (Rubinshtayna street, Liteyniy has a few great clubs too - Coyote Ugly and another one.. Not sure what the name is).