most pools i believe "close" at midnight
the slide will be shut down (ie - no water running/roped off) when the lifegaurd goes off duty (most places, around 10)
however...we've been in resort pools after midnight...as long as you aren't SUPER loud...they won't kick you out.
just be warned...it's swim at your own risk after lifegaurds go off duty.