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 :)