Superku described how to make a 2d rpg style collision detection. I described how to make a Mario style game collision detection. To achieve what you want take my style a bit further and have the script look at the pixels to see if they are "alpha" or invisible and still allow the movement.

Your game will only be limited by your skill and nothing else.