I suggest that Ringo Starr was the first drummer to really give a song "more cowbell". I'll have to go home and dig into my CD collection to tell exactly which song was first, though.

Well, actually it was probably somebody else, probably on some Motown or Stax single. But Ringo is usually the first to come to my mind.