Don't know why I never thought of having a water snake as a captive, but sounds awesome.
I'd imagine you need a large tank for something like this. I would want one just be able to see the snake really swim its little heart out. I love the way snakes swim. I'd think they would need a 125 gallon and up no?