Councils left to find homes for more than 500 Afghans, 300 of them children, as Home Office winds down support