Why do you feel 'lighter' in water than in air?

Water is denser than air, and thus has a buoyancy effect that supports your weight more. You feel lighter because you are lighter. A scale under you would reflect the difference. Bear in mind, there is a difference between "weight" and "mass". Your mass would still be the same.