[2.5] Support custom socket address resolution when connecting to Valkey across all clients

### Description
The original issue is #4396 and Java was added via PR #5328

### Checklist

- [x] Python: #5876
- [x] Node: #5890 
- [x] Go: #5891 
- [x] C#: https://github.com/valkey-io/valkey-glide-csharp/pull/392
- [x] PHP: https://github.com/valkey-io/valkey-glide-php/pull/196
...


### Additional Notes

_No response_