[release/8.0] Backport Enable default azure credential in PublishArtifactsinManifest

[MilenaHristova]

To double check:

• [ ] The right tests are in and the right validation has happened. Guidance: https://github.com/dotnet/arcade/blob/main/Documentation/Validation.md

Backport of https://github.com/dotnet/arcade/pull/14820 and https://github.com/dotnet/arcade/pull/14877