Councils are haemorrhaging funds as they attempt to meet the rising costs of record numbers of families living in temporary accommodation, MPs have warned.