The Black Sabbath rocker, who has died aged 76, had a second career as a beloved 2000s reality TV star.