Without a visible water leak, the best way is to have a professional inspect the pipes with special cameras that can document the condition of your pipes.
Discoloration in the water is a result of corrosion or rust and cast iron pipes are especially vulnerable. Discolored water is the most visible sign that you need to replace cast iron pipes