You might not like a "ding," but I find the Crane sold by Soma is excellent. I hit it once when approaching people on the MUPs, and nearly always get a "what's that?" response. When they see me or I then say something, they know I'm coming and leave room.
it's a big, very melodious sound.