Add worker-side custom state backend support

[amoghrajesh]

Body

The default state backend routes task state reads/writes through the Execution API (MetastoreStateBackend). Some deployments need to keep storage credentials on workers rather than the API server — this issue tracks adding a worker-side bypass path for that use case.

Committer

• I acknowledge that I am a maintainer/committer of the Apache Airflow project.