I made a simple water fountain for my dogs using a small fountain pump and "utility grade" copper tubing (3/8" OD) that I bought from Lowes. Is Utility Grade copper tubing safe for potable water? I didn't solder anything, just bent the pipe to get it out of the way and put a fitting on it to keep the sharp ends out of puppy reach.
Here's a picture of the fountain (don't laugh at the bends! it gets the job done!):