Story scripts have an event for this, called
ObjectTurnStarted. From that, you can then check if the object is a player, like so:
IF
ObjectTurnStarted((CHARACTERGUID)_Player)
AND
CharacterIsPlayer(_Player, 1)
THEN
CharacterPlayHUDSound(_Player, "MySoundName");