Q: Is there any way to handle the execution of SSIS packages stored locally?
A: Azure Automation works on Azure resources. It cannot be used for executing local SSIS packages.
In some cases, you may still need a scheduling tool (which might be a VM with SQL Agent).