A casanova is a promiscuous man.
The word came about after an Italian adventurer, Giovanni Giacomo Casanova (1725-1798), wrote vivid accounts of his sexual encounters in his extravagant autobiography.
Some cats drool when they are happy or when they sleep.
If it is a lot; it might indicate a tooth problem.
In that case, have a veterinarian take a look :)