Water is categorized as either hard or soft based on its mineral content, with hard water, high in minerals, posing risks to appliances and pipes, hence necessitating water softening to reduce mineral concentration.