You should not build any stadiums for a private team using public money, the only stuff you should build with public money is stuff aiming for public use (example: community centers, bicycle race tracks that anyone can use, public olympic swimming pools for anyone that wanna learn and train, and so on).
The World Cup stadiums are right now mostly abandoned, and giving us lots of trouble, some of them saw like 3 games during the tournament, and were never used again, it is a waste of money and land.
Other stadiums now we found out that were just a means to funnel corruption money in certain people pockets, and even the stadiums that ARE in use, don't made the government profit.
The World Cup in fact made the country lose money, the tourist spending don't covered all the money we lost. (and no, it didn't drove the economy either, one of the effects of the World Cup is that the government defaulted on many companies, that were forced to also default, and so on, resulting in my parents shop being defaulted too, and now we are in deep shit, including struggling to buy food sometimes, my parents are unsure when a potential new costumer shows up, if they sell because we desperately need the money, or if they refuse the sale because we've been defaulted too much and cannot afford another default).