Been there, done that several times too many times to count.
Type L is very common for residential - not too cheap, not too expensive. Pinhole leaks that aren't caused by some outside force is simply caused by the water flowing within. The harder the water, the sooner it will leak. Freezing...