Put it at the end of the thirsty setup, right where the water should appear, then follow it with a bell ding to mark the payoff. Keep it as the single beat in the scene, and save a bigger impact sound for the moment the bottle is shown empty.