Birmingham councillors praised the legacy of iconic band Black Sabbath – but also said more could be done to protect the city’s heritage