Place it at the very end of a scene, just as a character turns to leave, then follow it with the Discord Disconnect sound to close the moment cleanly. For a longer goodbye, put the No No Wait Wait sound just before it, so the failed attempt to stay makes the departure land harder.