I have the same problem with my riverwater in my hot water tank at my cabin. The heat kills the bacteria and it smells. Chlorine should be used to kill the bacteria and then there is no smell.
I made a small device that drops chlorine into my water to kill the bacteria. The smell is gone.