There's always the possibility that Holland could move into more of a mentor role for a newSpider-Man (Miles Morales, perhaps), but there are no teasers for that in No Way Home so we can only ...
Spider-Man's next villain should be Wilson Fisk/Kingpin, bringing a new dynamic to Peter ... ultimately tied back to Mysterio, he returned home to find his identity revealed to the world.