If you want the water to reflect things correctly, try to position the cubemap camera at the screen cameras x and z position, and use
water_Y - (screen_camera_Y - water_Y)
for the Y-position of the cubemap camera.
water_Y - (screen_camera_Y - water_Y)
for the Y-position of the cubemap camera.