Why does clean water develop a "musty" smell ?

This is common in unsoftened well water; you have hard water. If this is not well water, I would suggest contacting the water department to see if they have done any recent work on the pipes and explain the odor to them; they may ask you to bring in a sample to be tested.