python: provide OpenTelemetry integration

### What feature or improvement would you like to see?

There's a 'standard' contrib module: https://opentelemetry-python-contrib.readthedocs.io/en/latest/instrumentation/dbapi/dbapi.html

Do we recommend this or do we integrate ourselves?

Start with the linked opentelemetry-python-contrib DBAPI instrumentation documentation and compare its recommendation with the needs of Arrow ADBC's Python database connectivity API. The issue is complete when the project has decided whether to recommend that module or build an integration, with the required scope documented.

Written by the indexing model from the issue text.