The Scottish Government has been accused of ‘abandoning’ its stance on local councils in the Housing Bill.