Automatically dump Go backtraces periodically

[lidavidm]

Try to help track down adbc-drivers/bigquery#74

We can do this by:

• Adding the pprof server in debug builds
• Spawning a background Python thread to poll this (this should not get stuck because adbc should be releasing the GIL)