That's amazing how clear the water is... it must be fresh spring water. Hopefully, if it's truly an old cistern, then you can drain it, and look in the bottom for stuff people threw in there.
MAN... I wish I could air-lift the little bulldozer I use for treasure hunting to the Boston area and we could start pushing everything out of the way!
Good luck!!