Using a hotel for temporary accommodation to house homeless people short term cost a council £172,000 last year.