The word aquifer typically describes an underground source of water.
There are no categorical antonyms for this word. However, one could loosely use words describing places characterized by the absence of water as antonyms, e.g., desert, dustbowl, etc.