The metal legend died on Tuesday just weeks after he took to the stage for his final show with Black Sabbath, with his family confirming the sad news in a statement