Soft water is water which has a relatively low concentration of minerals--particularly Calcium and Magnesium dissolved in it.
It is said that Soft Water increases the effectiveness of soaps and detergents, however there is some question regarding its drinkability. Brewing the pilsener style of beer requires very soft water.