There are many mods released for this purpose where developers add quests, items, RPG play style, etc. One of them is called The Ultimate Quest Mod and can be found on the Minecraft Forums. Visit Google to find the mentioned mod besides all other available ones.
The Ultimate Quest Mod is based on Dungeons & Dragons game which is a RPG.