Celebrated with a major show at Tate Modern, the performer, designer and club promoter created brilliant art on a shoestring