In short, mod_perl is an extension to Apache to make Perl code run better under Apache. The homepage, or at least a very good starting point seems to be http://perl.apache.org.

For the differences, there are some sites, but I can't find them right now and my best friend just came to visit - sorry, I'll put an update here later ...