This probably varies on each resort. Generally the pools open around 9-10 depending on the season so the slides would be open then.
However I have seen people going down some of them before the pool was open. I don't know if they jumped a gate or if the water was turned on or not though.