It first appeared in the episode, "Bubblestand." In the episode, Patrick and Squidward both try to do it, but end up blowing puny ones. To help people blow bubbles, SpongeBob shows them the "technique", the label of bubbles is "Super Bubble". Although he is a pro bubble blower, none of his bubble creations (usually surface animals or boats) have lasted forever, because all bubbles pop eventually (usually when Patrick takes a picture of them). It seems that SpongeBob is the best bubble blower so far in the show. Bubbles appear in every episode of SpongeBob SquarePants, created by landforms, movement of things, or vibrating. Sometimes they just simply appear in the background. Bubbles in Bikini Bottom are nowhere near as physically correct as real life bubbles, probably because of how they are created. For example, fish moving in real life would not create bubbles like it does in Bikini Bottom.
In "Atlantis SquarePantis," it is shown that bubble blowing has been around for centuries, and Atlantis is home to the oldest in existence. Unfortunately, Patrick pops it when he takes a photo, which creates a major issue.
In New Kelp City, bubble blowing was outlawed in the city cause of The Bubble Poppin' Boys until SpongeBob blew them away in a giant bubble. When SpongeBob became mayor he made it legal to blow bubbles (as seen in What Ever Happened to SpongeBob?). However, the city was soon over run with bubbles.
In Battle for Bikini Bottom, SpongeBob uses bubbles for some of his main attacks including a viking helmet, bowling ball, shoes, and cruise missile
For the more info of the subject of the hobby, go to this page.