MPs warn some regions will run out of water within the next 20 years unless "urgent action" is taken.