An iconic landmark in Sheffield, which also featured in an Arctic Monkeys song, has finally been restored for the first time in a long time.