ENH: Allow third-party packages to register IO engines

[datapythonista]

• [X] xref #61584
• [X] Tests added and passed if fixing a bug or adding a new feature
• [X] All code checks passed.
• [X] Added type annotations to new arguments/methods/functions.
• [X] Added an entry in the latest doc/source/whatsnew/vX.X.X.rst file if fixing a bug or adding a new feature.

Added the new system to the Iceberg connection only to keep this smaller. The idea is to add the decorator to all other connectors, happy to do it here or in a follow up PR.