A Birmingham councillor said the project would 'transform the support available to some of the most vulnerable children in our region'