workflows: Upgrade to tuf-on-ci 0.5

[jku]

This update is a result of copying workflows from tuf-on-ci-template main branch.

The workflows are more complex but have some nice features:

• automated repository tests
• issues get filed automatically if something fails

Fixes #85