AzureScriptResource to check provider registrations

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

I have found that using deploymentScript resources (AzureScriptResource in Aspire) has a strange failure mode of silently hanging with no error messages presented, if the subscription doesn't have the required resource provider registrations. This isn't Aspire's fault, it's the deploymentScript resource type that's responsible for the silent failure, but it could help the user in this situation by checking that the providers for storage and container instances are registered on the subscription.

### Describe the solution you'd like

Either:
- pre-emptively check the resource provider registrations
- detect a hang on an AzureScriptResource and fail the deployment, explaining why

### Additional context

I would expect this to manifest as a mysterious failure mode for any Azure hosting integrations that use deploymentScripts to access the data plane, when they are deployed to a brand new subscription with no resource providers registered. An example would be the Azure SQL hosting integration. I haven't tested this. I only encountered it when trying to develop my own custom hosting integration.