Fans in the legendary Black Sabbath frontman's home city Birmingham will get a chance to say farewell.