Add a new IPipelineHookAsync interface with all async methods.

Change the PipelineHooksAwarePersistStreamsDecorator in a way that:

• it can handle both sync and async hooks (as two separate lists)
• async hooks will be invoked after all sync hooks have been run
• when an async hook is called by a sync function, it will be called with something like: x.SelectCommitAsync(filtered).GetAwaiter().GetResult()

Improve tests to verify sync and async pipeline hooks works as expected.