Add support for a CallOption which specifies Basic and Bearer Authorization headers to C++ and Python clients.

Reporter: James Duong / @jduo
Assignee: Lyndon Bauto / @lyndonbauto

PRs and other links:

• GitHub Pull Request #8724

_{Note: This issue was originally created as ARROW-10487. Please see the migration documentation for further details.}