I know this thread is a year old, but I've been toying around with this exact same idea. We have a Berkey water filter setup on our counter that seems to always be empty.
My original thought matched the ideas discussed here regarding use of a float switch. After considering the same issues...