The Black Sabbath frontman, famously known as the Prince of Darkness, died on Tuesday at the age of 76 - just weeks after performing his final show with the band