There really isn't one good answer. The age of your house's plumbing and electrical installations, and the codes that applied at the time, can affect it.
Your water line might be metallic all the way to the water co. shutoff (or well head) or it might be polyethylene plastic (PEX). If you have a well, there's a pressure tank in the way which may or may not have a very good ground bond between the inlet and outlet pipes.
If you have an older water meter, there might be a nice, big bronze "bridge" clamped to the inlet and outlet pipes, spanning the meter body, which ensures electrical continuity and provides structural integrity -- but those are pretty much vanished in modern installations. The newer meters may have non-metallic housings and rely on the way the plumbing runs to create (or not) a ground path.
The electrical panel must have some means of clamping bare copper to a nearby cold water pipe, which bonds the indoor plumbing through the panel's bus to the ground stake. That's the safety ground that ensures your plumbing and the panel are at the same ground potential.
While the whole system - building ground wiring and plumbing - should be equivalent as "ground", modern codes direct you to use the electrical wiring ground rather than a plumbing ground for a couple of major reasons. One, plumbing and the connections to plumbing can be subject to electrolytic reactions over time which will change the connection and conductivity characteristics, making their performance as an electrical ground unpredictable. Second, copper plumbing may be replaced over the life of the building, and non-metallic pipe may be spliced in. The pipe you're thinking of using as a ground may not be electrically connected at all with the rest of the plumbing.