Just to prove I am degenerate, I just threw a quick one-line shell script together that beeps when my hit counter triggers:

  tail -F -n 0 /var/log/visitlog | while read ; do printf '\a' ; done

Now if only somebody would visit my site.