Sounds like you're looking for RPG Maker VX Ace. It goes on sale regularly for only a few pounds/dollars. Alternatively, you could try RPG Maker MZ which is a lot more expensive but more professional. Here's how they describe VX Ace:
Simple Enough for a Child. Powerful Enough for a Developer.
RPG Maker VX Ace improves on every aspect of creating your very own epic adventure. An immensely powerful editor, Ace supports multiple tilesets, offers full control over autoshadow and has a very flexible features system.
Ace gives you all the tools you need to make that game you’ve always dreamed of, including the following features:
• A powerful map editor to build your world.
• A database to track your characters, skill, equipment and more, all improved with the powerful new flexible Features system.
• New event options, including support for Ogg Theora video.
• An expansive set of default resources, including a built in character generator to create your own sprites and faces.