I believe you have to be a resort guest to rent from the hotels. At least that is how it used to be.
However, you can rent the canopy boats, watermouse, and maybe pontoon boats from Downtown Disney. That marina is open to everyone - resort guest or not.