It's not a single effect, it's a number of different ones which are typical of scrapbooking. I would recommend searching for a dedicated forum for 'scrapbooking with Photoshop Elements'. You'll learn the basics of scrapbooking to make composite images with backgrounds, textures, frames, decorations etc.
Transforming photos into sketches or paintings is important and here the result looks like a regular painting. The various 'filters' available in Elements for sketches ane artistic rendering don't match your example, but they might help you to get very good results.