GIMP! First layer: transparent or whatever background you want.
Second layer photo, make it as transparent as you like.
Third layer, other photo, again, as transparent as you want using the layer function. =)
Then move one on top of the other, and adjust transparency for both. Really simple, but turns out fantastic when done correctly!