New private sector accommodation policy approved but Northampton councillor says it risks 'revolving door of homelessness'