The Black Sabbath frontman died on Tuesday at his home in Buckinghamshire just weeks after bidding farewell to fans at his final show at Villa Park