It’s called Helmholtz resonance. The sound is bouncing off of the bottom of the container and reverberating between the top of the container, and the top of the water. As the container fills, there’s less room for the sound waves to reverberate, which makes the waves shorter, and thus sound higher pitched