This is a fun item. The "TWEET!" really is attention-getting. For a brief period of time, the item was favored by PvP-ers because the 'startling' effect would break other players' stealth. (Blizzard hotfixed this, naturally.)
Using the whistle will cause players and NPCs to react; NPCs will also briefly turn to face the user.