North Northants Council has revealed there are more than 6,000 households on the social housing waitlist