[water] named pipeline for water middle-end lowering

[ftynse]

This is also constructed in python and we don't want duplication / incorrect test coverage

Later, turn this into a named pipeline

Originally posted by @ftynse in #1016