The council said the loss of a six-bed family home would ‘inhibit it from reaching its housing targets’ and the city already had enough accommodation for vulnerable children