https://metacpan.org/pod/Net::SSH#FREQUENTLY-ASKED-QUESTIONS says to use keys (which is my first recommendation) or to use Net::SSH::Expect (which would be my second recommendation). It's also possible to wrap a command-line SSH client with Expect, but why bother when you have the other two options?

Also, while search.cpan.org is not working try https://metacpan.org instead.