Investigate having `user_agent` support driver version

[jackwotherspoon]

Now that we support asyncpg and pg8000 we should try to add the driver being used by the connector's client to the user agent string

https://github.com/GoogleCloudPlatform/alloydb-python-connector/blob/main/google/cloud/alloydb/connector/client.py#L28

[jackwotherspoon]

Added support for driver user agents as part of #191 but it is not a long-term solution. Since we support only asyncpg through the AsyncConnector class and only pg8000 through the Connector it works currently. But it would not if we were to add support for a new driver so it needs improving still.

[rhatgadkar-goog]

We should look into whether this is possible to do without having to create a new AlloyDBClient for each driver. See this for the discussion about this: #416 (comment)