(pipes-sources): Add Self managed Apache Kafka stream source for EventBridge pipes

### Describe the feature

Add a implementation for the Self managed Apache Kafka stream source for EventBridge pipes in the `pipes-sources` module.

### Use Case

For feature completeness of the L2 pipes module this source is required.

### Proposed Solution

_No response_

### Other Information

_No response_

### Acknowledgements

- [ ] I may be able to implement this feature request
- [ ] This feature might incur a breaking change

### CDK version used

-

### Environment details (OS name and version, etc.)

-

Start by reading the existing implementations in the `pipes-sources` module and how EventBridge Pipes stream sources are represented. Determine the required scope for a self-managed Apache Kafka source; done means the source is implemented there and provides the requested feature completeness.

Written by the indexing model from the issue text.