So I was looking at the chords of a simple song in G major scale. The only 3 chords it's using are G, C and F, all major. i don't understand from where you get the Fmaj? if it was F#min, that makes sense to me. Is this as a result of mixing G and F scales together?
Often this sort of thing is explained with parallel keys. Songs in G major can use the notes, therefore the chords, from G minor. In Gm (natural) there are F A and C, producing the F chord. So it's sort of in the family. That apart, in the key of C, the three prominent chords just happen to be C, F and G. The difference here is that most songs in G will have the F# note (usually accompanied by a D chord, sometimes Bm or F#o). Using an F note in the melody sometimes has G7 under it, but the F chord fits sonically, if not in the basic theory.
If you want to look at it from a different perspective, think modally. G Mixolydian contains the same notes as C major, so the F chord could be construed to come from that.
This is simply called borrowing. In this example, it is most likely borrowing from the key of C major (C, F and G are very commonly used chords in this key) as C is the 4th of G.
One could also consider the use of F major as a way to bring in the dominant 7th of G - dominant 7th of G is F whereas the major 7th is F#.