aws-ecs-patterns: service connect support

### Describe the feature

At this time the different *Service (eg ApplicationLoadBalancerFargateService) that can be created with the ECS Patterns lib do not support ECS Service Connect as available in the [ECS module](https://github.com/aws/aws-cdk/tree/main/packages/aws-cdk-lib/aws-ecs#amazon-ecs-service-connect).

### Use Case

Support ECS Service Connect

### 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

2.93.0

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

all

Start by inspecting the ECS Patterns library and the service constructs named in the issue, such as ApplicationLoadBalancerFargateService, then compare their options with the ECS Service Connect documentation linked in the issue. Done means the different ECS Pattern services support Service Connect consistently, with coverage for the supported configuration and tests for the resulting behavior.

Written by the indexing model from the issue text.