[CT-2604] [Bug] StopIteration when publication for dependency not found

[MichelleArk]

Introduced in: #7656

When a project in (a non-empty) dependencies.yml is specified that is not provided as a PublicationArtifact dbt crashes with StopIteration

Reproduction case:

-- dependencies.yml
projects:
  - name: project_a
  - name: project_b

dbt = dbtRunner()
dbt.invoke(["parse"], publications=[PublicationArtifact(project_name="project_a")

Current Behaviour:
dbt crashes with:

  File "/Users/michelleark/src/dbt-core/core/dbt/parser/manifest.py", line 846, in load_new_public_nodes
    next(p for p in self.publications if p.project_name == project.name)
StopIteration

Expected Behaviour:

Runtime Error
  A dependency on project project_b was specified, but a publication for project_b was not found.