The water seems to enter the copper tank through the bottom pipe, and the
water is a dirty sandy color.

Probably a heat exchanger coil leak in the cylinder. This can only be fixed
by replacement.

Christian.