Absolutely, but slides are also one of the hardest items to insure on your home. Insurance companies tend to treat slides like trampolines: accidents waiting to happen. You’ll be charged accordingly, so be prepared for that.
Aside from that, there’s really no limit to what you can do with a slide in your pool. They can be built into a rock feature or stand alone. Your pool builder will work with you to make sure you have the correct depth and area necessary for safe slide construction. You’ll probably also want to invest in a few extra safety features, like fences or covers.