I'll pick songs for both teams I've been part of: Toronto North Stars and Newfoundland Berserkers (technically when I was there they were still called Lethbridge Lions). My approach will be more "would this fit thematically?" instead of picking a song that would work as a real goal song.

Toronto:

Borknagar - Up North. I probably would've never thought of this song as a goal song, but I like it so much (basically listening to it nonstop, it's a masterpiece) so I had to bring it up and it somewhat fits well thematically and perhaps some short parts of it could actually work as a goal song.

Newfoundland:

Technically we could just pick any Amon Amarth song here. Seriously, they even have an album called "Berserker", what would work better? I was thinking of mixing the intro of "The Pursuit of Vikings" fading into the "Raise Your Horns" chorus could work. Or really either of the two. If we stay with this band, they also have a song "Under The Northern Star" that could thematically work for Toronto as well, but it's not goal song material.