Actually, there are no ill-health effects from drinking rusty water, but I wouldn't be drinking it.
Hi
Welcome to the MedHelp forum!
This can cause iron overload and discolor the water. Also though not a health hazard as such, it will cause corrosion of pipes and this may cause impurities to mix with drinking water. Take care!