The dreams of aspiring performers in West Yorkshire will "turn to dust" unless a new home is found for a performing arts