The Castle of Lucretia(1997)

Original title: Lucretia - Una stirpe maledetta

This is an adult fantasy about kings, queens, & other denizens of a castle. The sexual shenanigans take place in ancient times, and the focus is on a particularly adventurous princess called Lucretia (or Lucrezia, depending on which language you see it in).