Councils told to offer ‘safe and appropriate home to anyone sleeping rough