Some investors see fortunes to be made in the U.S.’s hottest oil field—by speculating in water, not crude.