Let It Rain ~ Rain down spout drain: DIY projects. could be made as an "over flow" drain for underground water tank storage
Hide the downspout with a trellis. Hide your rain spout by transforming into a decorative climbing support for your favorite flowering climbing vine. I really like this idea and it looks great too.