You should only need to set it playing at that object once (start of layout) and keep it looping, the player will only hear it when they are close to the object.
However, it looks more like an issue in your path to the sound file than in the XAudio2 object.
Try: apppath & "/sounds/water.wav"