Update dotnet worker pipelines to trigger integration tests pipeline

Update dotnet worker's official and public pipelines to trigger [tests](https://github.com/Azure/azure-functions-host/issues/11512) pipeline and succeed only if the tests pass

Start by locating the dotnet worker's official and public pipeline definitions and review the linked integration tests issue (#11512). Done means both pipelines trigger that tests pipeline and report success only when the tests pass.

Written by the indexing model from the issue text.