If you're looking for manga similar to Urara Meirochou, you might like these titles.
In order to become a skilled magic user like her mother, Yume Kikuchi leaves home and travels to Tokyo for training. Her instructor, Masami Oyamada, runs the Oyamada Magic Office which assists people in need of magical support. But although Yume shows great potential, she is too eager to use magic to solve everything, including situations that she doesn't fully understand! Yume sets forth on her journey to becoming a fully certified magic user, as she learns not only to develop her powers but also how and when to use them in order to help her clients.
One hundred and fifty years after its terraforming, the surface of the planet Aqua - formerly known as Mars - is almost completely submerged by water. The town of Neo Venezia, a replica of the old Earth city of Venice, is a city that lives in harmony with the water, and is a popular destination for tourists. Akari Mizunashi is a young girl who dreams of becoming a fully fledged Undine - a gondolier who ferries tourists around the beautiful city. With help from her friends she progresses with her training, discovering more of the many wonders of Aqua and Neo Venezia along the way.
Najaran is a young woman who just happens to be an apprentice Cepter. Cepters have the power to summon creatures from magical cards. Once, these cards were collected in a book called the 'Culdcept.' During an ancient battle, the book was destroyed -- its cards scattered far and wide. Najaran's master gives her a dangerous mission -- she must obtain information about the Black Cepters and their nefarious plans. If the Black Cepters rebuild the Culdcept, the arcane book of ages past will grant them unspeakable God-like powers!
Without really understanding what was happening, Rhea was chosen to be one of the fifty "apprentice hero" of the kingdom. Despite the apparent mistake, she unwillingly accepts this new adventure, armed with her manual under her arm. Right after bidding good-bye to her best friend, she encounters two weirdos who will quickly become her comrades, as well as the mysterious Burn, another apprentice hero who seems really skillful.
Neo Venezia, the pride of planet Aqua, is a quaint city filled with canals and easy-going people. Many companies operate their gondolas on the canals, giving tours to tourists and locals alike, but the most famous of them is the Aria Company. Follow the adventures of Aria's young apprentice, Akari, as she learns the tricks of the trade from her beautiful senior, Alicia. Together with her friends Aika and Alice, apprentices of rival companies, and their seniors Akira and Athena, they train their skills as gondoliers, meeting new people and learning new things about the city each day.