The Houston and Dallas mayors have told lawmakers that they support a proposed $2 billion fund to finance water projects across the state.