A council leader has called for a government-led pause on large-scale house-building over concerns developments may not have water supplies.