Long mythologised for its enormous size and ecological importance, Molly Codyre discovers the best way to see the Amazon is from the water