Since the Dragonfly hovers above the ground, can it also hover over water and other terrestrial surfaces?

Yes, we're definitely targeting the ground mode for the Dragonfly to be capable of all-terrain travel. You'll still want to be mindful of where it's flying, since while bodies of water should be fine, more hazardous substances could still cause environmental impacts to performance.