Stepwells are a very historic category of architecture that often combines both functional and amazing aesthetic properties. A broad duction to stepwells and stepped water architecture can be found in Wikipedia.