Consumptive resources are resources that are unable to be renewed or take a long period of time to do so. Non consumptive resources are resources like solar energy that don't use up any resources.
Consumptive water use is water that is use up. That has been consumed! Non consumptive use is water that isn't used up. Things like fishtanks or decoration intended fountains.