I agree that it's better to find a solution where you install all modules locally or in a non-system Perl from CPAN, rather than mixing them and globally messing with the system Perl without the package manager. But to your other question, on Fedora or Redhat systems you would use repoquery --whatprovides 'perl(Module::Name)' ('dnf repoquery' on Fedora) to find the package providing that module. I am sure there are similar queries you can do on Debian-based systems.