Use CPAN Shell (can be as root or client)

$ perl -MCPAN -e 'shell'
[download]

You will be prompted to specify or confirm the location you want to install your module.
This will most probably be : "home/yourname/perl"
Then do this:

CPAN> install Module::Name
[download]

It'll do everything for you.

Then you call the module from your script like this:

#!/usr/bin/perl -w
use lib "/home/yourname/perl";
use Module::Name;
[download]