For transparency, it is very important that things are sorted in the correct order.
If you are still getting sorting issues after putting the water in the transparent bucket… then either the water really isn’t in the transparent bucket… or your background is in the transparent bucket when it shouldn’t be.
Transparent bucket objects are always drawn after opaque bucket objects. Always.