Make reth-provider crate leaner

[mattsse]

Describe the feature

this crate contains a mix of traits and implementations that are widely used across the codebase and is now very bloated.

Things that are not part of the API should be extracted:

Tasks

Beta Give feedback

1. static file impl https://github.com/paradigmxyz/reth/blob/ad00e83e6240334e90f9f0fb84a8dca0c6d5be09/crates/storage/provider/src/providers/static_file/mod.rs
2. bundle state https://github.com/paradigmxyz/reth/blob/ad00e83e6240334e90f9f0fb84a8dca0c6d5be09/crates/storage/provider/src/bundle_state/mod.rs#L1-L1
3. Move CanonStateNotification out of reth-provider crate #9610
   A-db C-debt +2
   

this is a bit tricky because might depend on types, like BundleStateWithReceipts, which is also a bit messy

Additional context

No response