Sorry if I misunderstand your desired setup, but try something like this and let me know if it works for you - It "works" the way I think it should, but I'm not sure that matches what you have in mind. The sky (image) is NikitaNishita. The Cube is default white, the sphere is pure reflective (metallic 1, roughness 0) - the sphere reflects the NikitaNishita sky, except for a bit at the bottom which is picking up a bit of the HDRI texture from the transmission in the "water". And as you can see, the water is picking up the transmission from the HDRI (which has several "reddish" sections).
If this is no good, I'll delete the answer: