What is the point called when water can not rise above or visually seem to have a ceiling in the atmosphere? What makes that point ideal?
Clouds have ceilings and bases because the atmosphere is stratified. Atmosphere is stratified due to earth's rotation and variance of composition, humidity, density, temperature, and pressure from surface of the earth to the edge of the orbital space.
Clouds form under specific conditions of composition, humidity, density, temperature, and pressure. These conditions are often persisted within specific layers in the atmosphere. Complex fluid flow of air is also a contributing factor for layering within the atmosphere between air masses for varying density.
The answer is probably best summed up as the result of the physics of fluid dynamics.
I know this question has an answer confirmed, but I'll add my own comments for posterity's sake. There are different types of clouds. Buoyancy-driven (cumulus-type) clouds are the types that have the most definitive bases and ceilings.
The cloud base is approximately the Lifted Condensation Level, which is the height that the air near the surface would have to rise to to saturate.
If the parcel of air can get to the Level of Free Convection, then the parcel will continue to rise and accelerate until the parcel encounters more stable air. It then starts to decelerate.
The level where the parcel stops moving is called the Equalibrium Level.
There are other types of clouds with other formation mechanisms. Cirrus clouds, for example, occur when the clouds in the above process go so high that they reach freezing temperatures and are moved into other regions. Stratus clouds form in the above process when the parcel never reaches step 2. Fog may form from either advection or the air diabatically cools to reach saturation. Kelvin-Helmholtz clouds form due to inertial instability. Contrails form from the hot moist exhaust mixing with the cool, relatively dry atmosphere.
In a sense, the full structure of a cumulus cloud extends all the way to the ground. The cloud is formed from the convection of air rising off the ground. The rising column becomes visible as a cloud when the atmospheric temperature becomes cold enough to condense water vapor, and the level where that occurs is the base we see. From Wikipedia:
Cumulus clouds form via atmospheric convection as air warmed by the surface begins to rise. As the air rises, the temperature drops (following the lapse rate), causing the relative humidity (RH) to rise. If convection reaches a certain level the RH reaches one hundred percent, and the "wet-adiabatic" phase begins. At this point a positive feedback ensues: since the RH is above 100%, water vapor condenses, releasing latent heat, warming the air and spurring further convection.
In this phase, water vapor condenses on various nuclei present in the air, forming the cumulus cloud. This creates the characteristic flat-bottomed puffy shape associated with cumulus clouds. The height of the cloud (from its bottom to its top) depends on the temperature profile of the atmosphere and the presence of any inversions.
1. "Cumulus clouds". Weather. 16 October 2005. Retrieved 16 October 2012.
2. Stommel, Harry (June 1947). "Entrainment of Air Into a Cumulus Cloud". Journal of Meteorology. 4 (3): 91–94.
3. Mossop, S. C.; Hallett, J. (November 1974). "Ice Crystal Concentration in Cumulus Clouds: Influence of the Drop Spectrum". Science Magazine. 186 (4164): 632–634.