I'm not sure what you mean by animations - sprite animations, "story" events where the characters move around, movies (not possible in RMXP by default), or something I'm not thinking of - but anything in the game can be activated by a trigger or an event that activates on the hero's touch, in any version of the game. Just do the animation you want to as usual, but change the trigger type to "On Hero Touch" or whatever it says in whatever version of the game you're using at the moment.

Of course if you're asking HOW to do an animation, I'm not sure what exactly you're looking for, so there's not much help I can give.