(pipes-targets): Add API destination target for EventBridge pipes

[RaphaelManke]

Describe the feature

Add a implementation for the API destination target for EventBridge pipes in the pipes-targets 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.)

[garysassano]

This is probably one of the most essential targets, as it's used for implementing webhooks. I would personally need it to set up something similar to this.