Queue family that only support sparse binding

[pollend]

Is your feature request related to a problem? Please describe.
Currently o3de only supports a copy queue that needs both transfer and sparse binding. But this is not needed, needs support on devices that have a queue that only supports sparse binding.

ref: #17905
ref: #17673

[akioCL]

For supporting texture streaming on Vulkan O3DE uses a queue that needs to be able to do transfer and sparse binding operations. On most devices that support sparse binding, there's a queue that have both. On certain devices, the queue that supports sparse binding do not support transfer. We need to refactor the AsyncUploadQueue to use one queue for transfer and maybe another for sparse binding operations.