Sure. There are often different types of fanfics for various characters. In the case of Discord and Celestia, while there may be some inappropriate ones out there, many fans also enjoy creating and reading more innocent stories. These can range from humorous tales where they get into comical situations together, to more serious stories that delve into their backstories and how they came to be the characters they are in a non - sexual context.
One common theme is the idea of redemption. Discord has a past of causing chaos, and in many fanfics, his relationship with Celestia is part of his journey towards redemption. For example, Celestia may offer him a chance to prove himself and do good for Equestria.
One common theme is their power dynamics. Since both are powerful characters in their own right, fanfics might explore how they interact when their powers clash or complement each other. Another theme could be their different personalities. Discord is chaotic while Celestia is more serene, so stories could focus on how they handle their differences. Also, friendship is a big theme. How they become friends or maintain their friendship despite their differences can be an interesting story.
Create an interesting plot. It could be a conflict between order (represented by Celestia) and chaos (represented by Discord). Or it could be a story where they have to cooperate against a common enemy. Make sure the plot has a clear beginning, middle, and end. For example, start with Discord causing some minor chaos in Canterlot, Celestia tries to stop him in her usual way but fails. Then a bigger threat emerges that forces them to work together. In the end, they either defeat the threat or find a new balance between order and chaos.
Well, the plot could involve Celestia and Discord having to team up to save Equestria from a new, unknown threat. Maybe a powerful dark magic that neither of them can handle alone.
The theme of power dynamics is often seen in Discord x Celestia fanfic. Celestia is a powerful alicorn princess, and Discord has his chaotic magic. Fanfics play with how these two powers interact and balance each other. Also, the theme of forgiveness is common. Celestia has to forgive Discord for his past misdeeds, and fanfics explore the journey towards that forgiveness in different ways. Some fanfics also have a theme of discovery, where they discover new things about each other and themselves through their interactions.
One great Celestia and Discord fanfic is 'The Celestial Bond'. It shows an interesting adventure where Celestia and Discord have to work together to save Equestria from a new threat. Their interactions are well - written, with Discord's chaos and Celestia's grace creating a unique dynamic.
Another storyline could involve Celestia and Discord having to team up against a common enemy. Maybe an ancient evil that threatens Equestria. At first, they might struggle to work together due to their very different natures. Celestia is all about order and harmony, while Discord is chaos personified. But as they face challenges, they learn to appreciate each other's strengths and develop a unique friendship.
One popular Discord x Celestia fanfic is 'The Celestia - Discord Alliance'. It shows an interesting take on how their relationship could develop in an alternate universe. There are also some fanfics that explore their interactions during a time of crisis in Equestria. For example, 'When Discord and Celestia Face the Dark Magic'.
I'm sorry, I'm not aware of any specific luna x celestia non - adult fanfic at the moment. You can try searching on some popular fanfic websites like Archive of Our Own (AO3). They have a large collection of fanfictions and you might be able to find some good ones related to luna and celestia there.
For Celestia, her character could be developed by showing her struggle with her own perfectionism. When dealing with Discord, she might realize that her rigid view of order isn't always the best solution. This could lead to her becoming more flexible and open - minded. For example, she could start to see the beauty in Discord's chaos in some situations.