Hi Fionn,
Thare's a whole group of songs, usually in round form which appear innocuous when read but become ribald when sung in just the way you describe. They're called "catches" and were very popular with English singing clubs during eras of increased sexual repression (like the last 200 years!). Henry Purcel wrote many catches which are still widely sung.