Explain Like I'm Five

I understand that in order for an object to maintain circular motion, its velocity vector must be travelling perpendicular to its position vector and constantly changing inwards, hence an acceleration towards the center of the circle. I know that the acceleration towards the center is typically caused by other forces, like tension on a string, and that these are called centripetal forces I believe? However, objects in circular motion tend to want to be away from the center instead of towards. A bucket of water tied to a string and twirled around in a circle will result in the water staying in the bucket: if the water is exhibiting circular motion, would it not thusly be accelerating inward, and thus escaping the bucket? I've heard that it's a difference of frame of reference, but even looking from out to in, I can't see how the water would be accelerating inward and yet remain in the bucket without support. Would there not be some force pushing the water into the bucket? And yet, centrifugal force is considered a fictitious force. I don't understand. I know I understand some level of physics but please explain it like I'm 5 because I can't seem to actually understand this.