Usually air and water don't mix, but there's a lot that a Cancer can teach a Libran (Like understanding and handling their feels better). Out of all the water signs, though, a Libran is more likely to connect with a Piscean.
But that's just based on a typical Libran.