Add ability to log all interactions with a memory pool, by consumer

### Is your feature request related to a problem or challenge?

To help debug OOM issues in Comet, I would like to add a new `LoggingMemoryPool` that can wrap an existing pool and log every call that changes the size of the reservation. I can then analyze that information to better understand the events leading up to an issue that I am debugging (https://github.com/apache/datafusion-comet/issues/2452).

### Describe the solution you'd like

I am currently prototyping this in Comet (https://github.com/apache/datafusion-comet/pull/2521). I am generating debug logging such as:

```
[Task 486] MemoryPool[ExternalSorter[6]].try_grow(256232960) returning Ok
[Task 486] MemoryPool[ExternalSorter[6]].try_grow(256375168) returning Ok
[Task 486] MemoryPool[ExternalSorter[6]].try_grow(256899456) returning Ok
[Task 486] MemoryPool[ExternalSorter[6]].try_grow(257296128) returning Ok
[Task 486] MemoryPool[ExternalSorter[6]].try_grow(257820416) returning Err
[Task 486] MemoryPool[ExternalSorterMerge[6]].shrink(10485760)
[Task 486] MemoryPool[ExternalSorter[6]].shrink(150464)
[Task 486] MemoryPool[ExternalSorter[6]].shrink(146688)
[Task 486] MemoryPool[ExternalSorter[6]].shrink(137856)
[Task 486] MemoryPool[ExternalSorter[6]].shrink(141952)
[Task 486] MemoryPool[ExternalSorterMerge[6]].try_grow(0) returning Ok
[Task 486] MemoryPool[ExternalSorterMerge[6]].try_grow(0) returning Ok
[Task 486] MemoryPool[ExternalSorter[6]].shrink(524288)
[Task 486] MemoryPool[ExternalSorterMerge[6]].try_grow(0) returning Ok
[Task 486] MemoryPool[ExternalSorterMerge[6]].try_grow(68928) returning Ok
```

This data can be used to generate charts:

# Describe alternatives you've considered

_No response_

### Additional context

_No response_