Calderdale Council has spent millions of pounds on temporary accommodation, including bed-and-breakfast housing.