Many gardners do something like this. My father had 4 or 5 big barrels he had rigged together so that one would overflow to the others. Let them keep plenty of rain water on hand for the garden. Basically just had that green overflow hose shown in the image run the overflow into another barrel.
