The mod_perl Guide should be enough to get you started, and is something you should probably know about if you're going to be playing with mod_perl. For your particular problem, I think you'll need to have Apache compiled with DSO support, and add a:

LoadModule perl_module modules/mod_perl.so
AddModule mod_perl.c
[download]

to your httpd.conf. Do read or at least skim the Guide, however -- I built my mod_perl by recompiling it into Apache statically, so I'm no expert on doing it as a DSO -- and I'm even sketchier on what bits get installed if you only install files from CPAN. The Guide is a veritable fount of information.

Update: Changed libperl.so to mod_perl.so -- the Guide mentions the former, but I've also seen the latter. Try 'em both, I'd guess.

perl -pe '"I lo*`+$^X$\"$]!$/"=~m%(.*)%s;$_=$1;y^`+*^e v^#$&V"+@( NO CARRIER'