Just my 2 cents worth. Back home in New Zealand and in Australia in the less populated areas we collected rainwater for use during the year this water was stored in a large tank adjacent the
house and a small pump provided water to a header tank in the roof. This system works well and would be ideal for Long Island. Down on St John where I used to do a lot of diving the houses all had swimming pool basements that stored the water for use during the year this system works great for anyone living well above sea level the side tank works better for people in flood areas (like LI) underground tanks can be contaminated by saltwater or flood water.
I have installed charcoal filters in all of my gutters and I intend to put 55 gallon catch tanks on all three of the down spouts on my house any excess water will be used in the garden over the summer.
What do you think?