First using After effect for videos and Photoshop for pictures:
There is also alternate ways and websites if you don't have experience using AE or PS:
This is one of those websites that will really make you think that you really don’t need Photoshop for photo effects. Photofunia has over 100 effects to choose from with new ones being added constantly. There are effects that work with face recognition, that is they will search for “the face” in your photo and put it appropriately as required by the effect. Other effects use the complete photo.
Dumpr and FunPhotoBox
Dumpr is another website that lets you choose the effect, upload your photo and get instant results. Dumpr was mentioned previously on MakeUseOf. FunPhotoBox is also similar in concept. Together, all three sites give you plenty of effects and options to choose from and get the perfect effect you were looking for, according to your photo.
Mosaics and Collages
If you would like to create a photo mosaic or collage, check out pixisnap and photovisi. Photovisiis excellent for collages where as pixisnap can be used for creating photomosaics as well as collages. Also check out these cool photomosaic software.
TiltShiftMaker allows you to transform your real life photo scenes into miniature models. Just upload the photo, choose the area to focus on and presto you have your effect.
Looks great on photos of city scenes, mountains where the whole aspect of the scene has been captured in the image as opposed to a single object.
A photo effect, editing and photo enhancing web application that allows you to create montages, convert images from one format to another, create rounded corners, add 3d effects, create photo puzzles and much more.
It is said that color represents the mood of the photo. Pic2graphics allows to take colors(and thus the mood) of a photo and apply it to some other photo.
BeFunky lets you give various artistic effects to your photos. Just choose an effect, upload the photo, tweak some settings and you have an instant professional sketch or cartoon or an ink drawing!
Picascii and Photo2Text
Simple and fun, upload an image and convert it into asciiart.