The frequency of sound produced in an air column is inversely proportional to the length of the air column. As level of water in the vessel increases, length of air column above it decreases. Hence the frequency of sound produced goes on increasing. The sound becomes shriller.