Drew Molly, at the forefront of Corpus Christi water supply projects, has resigned