It is hard to find that exact transition effect that you see there. It is a matter of taking the time and searching on the different galleries out there.
Here is a nice one that may or may not have those effects.
http://store.dotnetnuke.com/home/prod...