Sale has ended but you can still get this app.
Download TransPhoto Now
TransPhoto

Official Description

Simple and easy:
1. Load a frame (photo) which becomes semi-transparent
2. Load a photo
3. Save or share the trans. photo