That's a lot of water signs. You are very emotional and most likely psychic or have great intuition. The Scorpio sun is a fixed sign. You are independent, serious, need privacy, strong, capable, sensual, and a born leader. Scorpios are strong-willed and don't see shades of grey, so your opinions are very fixed. But the other positions soften that a bit.
The Cancer moon rules your emotions, and you need security in your life, especially in your love life. Cancers are moody and changeable, but generally likeable social butterflies. This is a leadership sign, so you are a hard worker and usually take the lead. You are very imaginative and creative, and use that to your advantage. You get bored easily, and like to travel, especially by water. You are ambitious and plan for the future.
Pisces rising is the way others see you. Pisces is a gentle, retiring sign. You are easily approachable and are very understanding of others. You are very spiritual and not materialistic. You would give a stranger the shirt off your back. You are psychic or have telepathy with those you are close to.
Venus in Libra rules love and social life. You were born to be half of a couple, even half of a business partnership. You will want to spend most of your time with a lover, and hate to be away from them. You want to be pampered and to go out often to nice places. If you don't get a lot of attention, the Cancer and Pisces in you will have hurt feelings. But the Scorpio makes you tough and you won't take any nonsense from a lover.
I like this combination, and would love to see you studying a metaphysical subject or getting into meditation. It would be good for you, as Cancer also needs alone time. This contradicts the Venus Libra a little. You want to see a partner constantly, but do have that side that needs private time.