Net::SCP does not support password authentication and Net::SFTP/Net::SSH::Perl are mostly unmaintained nowadays.

A better option is Net::SSH2. Its SFTP capabilities are rather limited, but SCP will probably be enough for the OP needs.

Alternatively, the development version of Net::SFTP::Foreign, a rich SFTP client, can run on top of Net::SSH2 with the help of Net::SFTP::Foreign::Backend::Net_SSH2.