As the title says, I am looking for material or ways to suck water quickly from hardwood floor or carpet.
A wet (typically "wet/dry") vacuum - most commonly the most affordable form is a shop vacuum. You can use it like a "carpet cleaner" (which is a more expensive form) by spraying a cleaning solution and then sucking that up with the vacuum. Most are quite loud.
Image is an example of the type, not an endorsement of a particular brand or supplier.