have you considered a stock tank? they are designed for holding water? heres a link for rubbermaid stocktanks.
http://www.rcpworksmarter.com.(look under products/agricultural link)you can find them at most agricultural feed stores where they are much less expensive than the prices you see online.