One councillor urged the NHS to invest in the 'wonderful' Erdington community instead of removing the facility