Sukuna does die in the manga. The way it happens is quite dramatic and ties in with many other elements of the story, adding depth and tension to the overall narrative.
Since lemon fanfics are inappropriate, we should focus on their general characteristics from the official story. Asta is highly determined and energetic, always striving hard despite his lack of magic initially. Yuno, on the other hand, is more calm and has a natural talent for magic. They both have a strong bond as rivals and friends.
No. Ryomen Sukuna is a fictional character from Japanese mythology and modern manga/anime. He doesn't have a basis in a true historical event or person.
Nope. Ryomen Sukuna has no basis in reality. It's a product of the creative minds of the writers and illustrators who designed a captivating fictional character for the enjoyment of the audience.
Noelle could be a great addition. Her water magic is quite powerful and she has a complex relationship with both Asta and Yuno. She could be a source of both support and conflict in the fanfic. Another good character is Luck. His lightning magic and his rather unpredictable nature can add a lot of action and excitement to the story.