Well that is certainly a interesting request.
Does he actually mean to have the elevator cars carry water? Even without doing any research, I am fairly confident in stating that I don't think this has ever been done.
What is the vertical distance (head) from the sump to the roof tank?
Assuming that the goal is to actually have a tank built into the elevator car (or on the counter weight end of the cable), this seems like a bad idea because:
1. Water is heavy. The elevator system would need to be rated to lift a full passenger load plus the full water load. Initial costs would be higher, as well as maintenance costs.
2. You need to transfer the water from the sump to the elevator tank, then to the roof tank. This means you would need some sort of automatic coupling that could be relied upon not to leak. You might be able to get by with a gravity feed at the bottom, but it seels like you would need a transfer pump at the top (unless the eleveator goes above roof level).
3. The inertial effects of having water sloshing around is unlikely to make the elevator people happy.
4. Once a load of water is taken on, the elevator needs to go all the way to the roof to dump it. But not all elevator trips need to go to the roof. This means you need to either divert the elvator from passenger service to pump service, or pay to carry water up and down the building until a trip to the roof can be made.
5. Even if you are going to carry water only during unoccupied periods, the cost to maintain and operate an elevator has just got to be way more than the cost to maintain a standard pump.
6. What happens if there is a catastrophic failure of the elevator tank while the elevator is moving?