An aspiration to stop using bed and breakfast (B&Bs) accommodation to put up homeless people, has been revealed by a senior councillor