Create a new variable called DrinkSound and set it type to SoundCue, then tick on instance editable.

Add the highlighted nodes shown in the image below, location at the top of the image.

You can now set the Drink Sound in the Class Defaults of the BP_DrinkZone.