Provide a way for individual projects to specify which distributions they can run/test against

[alpar-t]

Related to #30874.

The distribution running in the integration tests, or started with the run task can be switched with the tests.distribution and run.distribution properties.
The problem is that no all projects are able to run with any distribution e.x. plugins being tested might depend on other plugins. On the other hand we want to make sure that the inputs are honored, so we can't silently match the distribution for some projects (i.e. use zip even trough zip-oss is required ), we want to ave tasks skipped in these cases.

To achieve this we need a better way to express distribution requirements for cluster formation so that projects can define distribution types that they need and the plugins can do all the setup without the individual projects having to deal with setting up the tasks to do so.

[elasticmachine]

Pinging @elastic/es-core-infra

[alpar-t]

Closed in favor of #46378