The music legend, nicknamed the Prince of Darkness, died on Tuesday at the age of 76 just weeks after he took to the stage for his final show with Black Sabbath, with his family confirming the devastating news