Thanks for the ideas so far and welcome any more.
I am thinking of something along the lines of a seperate tank for rain collection and a seperate one for moving it around the yard. I want to mount it either on a pallet or on a trailer. I could then tow it or if it was on a pallet I could use the forks. I like this thread I found but would like more thoughts.
http://www.tractorbynet.com/forums/build-yourself/61467-portable-water-wagon-project.html
Here are some pumps I found. Which one would be best/
Cabela's -- Rule Submersible Bilge Pump
I would like to set it up like the guy in the first link did so the pump could be used to pump in or out of the tank. I can't figure out a way to make this pump work that way, so any thoughts would be appreciated. of course I like this pump because I am cheap.