Transforming challenges into opportunities: how automation can increase efficiency and free up vital resources in local government