The Black Sabbath frontman died last week at the age of 76 and is body will be returned to his home city of Birmingham for a procession ahead of his private funeral on Wednesday