A guide to the best sea kayaking and stand up paddling along the shores of Connecticut and Rhode Island and in Long Island Sound.