Periodic saltation over hydrodynamically rough beds: aeolian to aquatic