Elected members had been asked to share their views on housing need across the district