North Northamptonshire Council has revealed that there are more than 6,500 households waiting for a social home, a third of which have been identified as "priority need"