Spiders, Cubins, or the Holy Cow — depending on your age — the Cork venue is about to take on a whole new lease of life