Add a test as a required status check that makes sure the generated provider is running

[ulucinar]

What problem are you facing?

Currently, we do not assert that the generated provider is running correctly against the latest upjet dependency.

How could Upbound help solve your problem?

We could integrate the local-deploy job we are using in the official provider repositories also in this repo to make sure that the template provider maintained in this repo is building & running as expected.