The Round the Horne shows and the songs Ramblin Syd Rumpo sang were written by Barry Took and Marty Feldman. The show was rather naughty in places and Mary Whitehouse (a campainer for so called good taste and morals)tried to have it stopped.

A couple of titles I have found are The Bogle-Clencher's Ditty ("tis my delight on a shining night and a foggy night as well"), The Cordwangler's Ditty, and Master Fumblers Traddling Air (sweet lass of hackney wick).
I don't think the Best Of CD is available anymore but there is a BBC tape still available (I think).
http://www.kennethwilliams.org.uk/ (no blue clicky)

here ya go
Cheers
Gary