The recognition on Saturday night marked the second time the singer was inducted into the Rock Hall, following his induction as a member of Black Sabbath in 2006