Someone else on the list can recommend good sailing dinghys, they're not something I have experience with. But the sailing will be much different from your 40 footer. Is there someone you're friendly with in your local marina who could spend some time teaching you the basics?
95 Catalina 30 Island Time
“If a man is to be obsessed by something, I suppose a boat is as good as anything, perhaps a bit better than most" - E.B. White