There are houseboat rentals in at least 38 of the 50 states, and in 4 Canadian provinces. Boats range from 25 to 60 feet in length, and sleep from two to a dozen.
Rental rates vary according to the location, season, duration, and boat size.
Fuel is not included in most rental agreements. LP gas is. Fishing guides, who will meet your boat at predetermined locations, would also be an additional cost. The Internet is awash in houseboat rental information. This site also has informative articles on houseboat handling, what to bring, and what to expect.