When you are ready with the snake charm in hand, search one of the urns to find a snake. Use the snake charm on the snake that appears, and then play your song for it. This will allow you to loot any urn for what's inside.