Mr. Puff was Mrs. Puff's husband. He was caught and killed by humans, and turned into a lightbulb cover for a lamp.
The only picture of him was in the episode, "Krusty Love," where he is shown getting turned on by a human hand pulling a switch. Mr. Krabs asked what happened to Mr. Puff, and SpongeBob replied that Mrs. Puff does not like to talk about what happened to him.