It would be nice to merge some of this comunity building topics since information are all around forum now.
Carl listed all 9 clubs in Mixology guide, along with drinks served there. (You need 42 popular drink recipes to finish mixology skill challenge Professor of Drinks, and in total there are 49 in all bars, plus that one unlocked with that challenge, so technically you really don't need all of them).
I just checked categories of LN Buildings and there are 9 different of them. Opening hours are automatically assigned to lot type:
Vampire Lounge (Plasma 501) (2.00PM-2.00AM)
Exclusive Lounge (Prosper Room)(2.00PM-2.00AM)
Fusion Lounge (Banzai Lounge)(2.00PM-2.00AM)
Disco Club (The Brightmore) (5.00PM - 4.00AM)
Dance Club (The Grind) (5.00PM - 4.00AM)
Poolside Club (Aquarius) (5.00PM - 4.00AM)
Sports Bar (Bridgeport Sports Zone) (11.00AM-3.00AM)
Dive Bar (Waylon's Haunt) (11.00AM-3.00AM)
Local Watering Hole (Eugi's) (11.00AM-3.00AM)
My computer whiz has the option to hack into venue listing, and there are 4 of them listed:
Aquarius
Banzai Lounge
Plasma 501
Prosper Room
I think it's safe to assume that these 4 attract higher level celebrities but not necessarily since they go to hot pots for that night (find in newspaper).
Now, there is lots of usefull info on topic on Late Night/Editing existing games/towns with Late Night ( I don't know how to put a link).
And one more thing, while testing, I put single bar on empty lot and tons of Sims came (in brand new SV) not to mention crowd in The Grind, cars kept coming in, in those few Sim hours I tested even Agness danced on counter
)