Government told to wake up and smell the coffee over lack of affordable housing in North West