The late-night haunt in Goose Gate has been reimagined as one of the most opulent spots in the city centre, now called Noiré Lounge