A beloved rock and metal venue has been reduced to dust as demolition has almost been completed ahead of the building being replaced by student flats.