Feature: Let connectors provide their own fatal errors

### Feature description

On [Conduit v.0.12.0](https://conduit.io/changelog/2024-10-10-conduit-0-12-0-release), we provided the ability to automatically recover from errors.

In Conduit, a [fatal error](https://github.com/ConduitIO/conduit/blob/main/pkg/foundation/cerrors/fatal.go) causes the pipeline to go into a [degraded state automatically](https://github.com/ConduitIO/conduit/blob/main/pkg/lifecycle/service.go#L780-L784), which is something some connectors might want.

The request here is to let connectors provide those.