The easiest way is probably to connect the ‘pressed’ signal of the button to a node managing your game sounds. In that function, you can just create a new sound player node, load/attach the sound you want to use, and then when the sound player is finished you can (optionally) free it from memory.
(We can better tailor our answers if we know which version of Godot you’re using :wink: )