Pep Guardiola has just extended a one year contract with City and he is going nowhere for now. However, Pep will have to decide where he would be going to after his contract expires in 2026 if City did not give him a contract extension again. I don't know if Pep will choose to retire as a coach of a National team or not, probably, he might find his way to SPL.
There will be a lot of links about Pep Guardiola but obviously we know that Pep has extended his contract with Man City, meaning that nothing else has changed, it is certain that the news involving Pep to Brazil is excessive, even for next season it might be different news.
So far Pep is still comfortable coaching the club so he extended his contract with his current team, has made many contributions including several trophies so he will not just leave.
But I believe in surprises where he can decide to leave, like Klopp leaving Liverpool suddenly.