Most of the money is being spent on recruiting carers from outside agencies - more local people are needed says city council