A new nightclub is set to open soon in Sheffield at the site of a legendary lost club.