I don't think Psilocybin mushrooms or LSD are used as a club drug.
In fact, I'd say LSD is used more as a party drug than it is used for anything else.
Festivals are different because there is lots of space. Clubs are too compact and contained for LSD, can make people claustrophobic.