I believe the primary purpose for this product is for cosmetic fountains. But they do sell larger modular holding tanks for rainwater capture and storage. Could easily work for gardening or something else.
Cisterns were an absolute necessity for homesteads in South Louisiana in the past. Below is a video about building storage tanks in third world countries that I find interesting.