The story
Probably after Looney Tunes cartoon characters, because these characters are noted for their silliness.
Etymology from Wiktionary, CC BY-SA 4.0.
loony tune
Today it means: A silly or crazy person; a person whose actions are unpredictable and irrational. Full definition →