Add Custom Icons to built in resources

### Is there an existing issue for this?

- [x] I have searched the existing issues

### Is your feature request related to a problem? Please describe the problem.

9.5 added the `WithIconName` API, but so far nothing in the core aspire repo actually uses this api. We should make use of this API

### Describe the solution you'd like

Resource types in the aspire repo should add custom icon to the built in custom resources.

There may also be value in a `KnownResourceIconNames` class to allow similar app types to share the same icon.
- Management UIs (redis commander etc.)
- Database / Database Servers
- Queue (kafka & rabbitmq)

If introducign `KnownResourceIconNames`, a bit of refactoring may also be needed to avoid deviation from `ResourceIconHelpers` in the dashboard..

### Additional context

_No response_