spanner: add transaction type to tracing spans

## Is your feature request related to a problem? Please describe.
this will help us identify the type of transactions in traces to better debug

## Describe the solution you'd like
A clear and concise description of what you want to happen. What should the API be? How would you use it?

https://github.com/googleapis/google-cloud-go/pull/13050

## Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

## Additional context
Add any other context or screenshots about the feature request here.