Councillors warn that rising demand and a lack of resources are leaving children’s needs unmet