Common Scripting Sites:
Hawkee
mIRC Scripts
mIRC.net - NOTE: This one doesn't always have scripts, but rather advice on how to make the scripts

There are others, some of which are linked to those.