The council has borrowed almost £250,000 over three years to pay for the temporary accommodation