I believe what you are looking for is to either ‘Disable Depth Test’ of your translucent material for the waterflow, or to edit the translucent sorting priority within the ‘Project Settings.’ This option can be found within your material properties in the expanded menu within the ‘Translucency’ settings.