Add automation to keep the provider build workflows up to date

[ringods]

How a provider needs to be build, packaged and released is mainly defined by Pulumi. They also have a lot of automation for keeping the Github Actions workflows up to date in all of the provider repositories.

We could benefit from having an automated setup serving two purposes:

• initial setup of the workflows for new providers being set up in Pulumiverse
• updating the workflows to support new features coming from Pulumi (e.g recent addition was support for Java)

Pulumi is aware that building & releasing a provider must become must simpler. There is planned work to make the pulumi/ci-mgmt a consumable artefact. This artefact, with the proper configuration, would be able to generate the correct workflows for a provider repository.

Let's follow up on that work, test it, provide feedback (issues & PR), so we can build on top of that effort.