Mark Fawcett wrote:

... The rainbarrels normally sold for such purposes
always overflow when we get too much rain and run out too quickly
when we dont get enough.

A friend of mine has half a dozen or so barrels connected in series
along the side of his garage. As soon as one is full, it overflows
into the next.
--
Nick Wagg