Can't find a horror movie i saw as a child

In 2006-2008 I saw a scene on TV where a man walks into (i think) a castle room with stone walls and floor, he sees a pool of (i think) blood, a few completely naked women appear from it and attract him, he sits with them, they start to kiss him and suddenly they show their vampire fangs and kill him, if i recall they drag him into that pool afterwards.

No gpt helped me find it.