my plumbing in my house is copper and starting to get tiny holes in it.
Was your house built in the 80's . There was a lot of inferior copper on the market then and it all began to pinhole. The only real solution is replace with new American copper pipes or change to different material. PVC, PEX
Highly acidic water can do that, but you'd notice the taste. It would be very sour. That's about the only thing that can really harm copper water lines. Electrolysis can cause similar problems, but you'd have to be directly charging the plumbing system with a AC/DC rectifier for that to really be a factor. I guess my answer is that I don't know. Poor quality copper to begin with? A freeze event that didn't just outright split the pipe but thinned the walls? Suffice it to say, but you have a very rare and expensive condition.
It's probably something to do with the water. Have your water tested, especially if you have your own well. If you're on city water, talk to the water department and see if others have reported similar problems. Another possibility is an electrical current. Make sure your copper plumbing is bonded to an electrical ground and that the grounding spans any potentially insulating connections (e.g., water meter).