It has a little sulfur odor but it's not terrible. Water is clear.
Have you tried a water conditioner? It makes the minerals and junk stay in the water (not a technical definition). Over time it will descale the pipes. I don't use one because it won't solve this problem.
In my hot water tank I have an electric anode. It works great, no smell in the hot water.