I'm waiting till we move before I buy them but there's some really nice rain barrels on Ebay. Plenty of them are more decorative so it's easier to convince the wife that we "need" them.
I'm piecing together an underground holding tank with a pump to bring it back up as needed. No real winterization needed like I'll have to with my above ground 50 gallon cube.
Look into Bushman (it's big $$$ but it's going to last). Link: Bushman
I might look for a tank from TSC or a similar place if they are less money.