Julie, love your pot head!
Snake plant in particular will absolutely not stay alive if you put too much water in a pot w/o a hole in the bottom. The roots will rot.
No plant that I ever put in a pot w/o a hole is still alive. It's the only rule I have for a container, it must have a hole for excess water to escape. There are folks who can do it, but I like to water plants, and will definitely drown one, with good intentions of course. Until I finally understood that plants need air and moisture around the roots at the same time, I 'overwatered' a lot of plants, a lot. Changing to a more chunky type of soil, not using pots w/o holes, and not watering plants in place that are sitting on drip trays/saucers has made a huge difference. Ever so rarely does a plant die here, the usual cause lately is when I accidentally leave pots where our dog can pee on them. (His garden ideas are way out there, though he does try to contribute! LOL!)
There's also water chemicals which can accumulate to toxic levels, and alter soil PH, to consider if not using rain water. Ground water tends to have lime, iron, all kind of stuff in it. Tap has chemicals like the chlor-s, fluoride, which can make many plants ill.
It's also hard to remove pots from decorative containers usually, when the time comes. The shape of yours is one I think a plant would get stuck in, getting slightly smaller near the top.