There's lots of gorgeous ideas here on Hometalk Cassie
Consider using something such as a small fountain or other such device to break up the surface of the water. Doing so will help ensure it doesn’t become a stagnant breeding ground for mosquitoes or other pests.
Check your towns codes, see if it’s permitted, and if permitted any size restrictions.
I have made many different fountains from inexpensive pottery glazed pots. Place a pump that fits the size of your pot with adjustable speeds in the bottom, threading the cord through the drain hole. You might need to slightly enlarge the drain hole with a drill. Mask the area around the hole with masking tape to prevent cracking. Silicone the hole around the cords with a good sealant. Let dry. Attach a length of stiff tubing to your pump, fill container with water and turn on the pump. Adjust flow to your liking. Cover the inside bottom of container with medium round stones. Enjoy! There are many other variations... Try U- tube. You will be hooked! The variations are endless!
Water feature pumps run on electricity. If you do not already have an existing exterior-rated electrical outlet, you will need to have one installed by a licensed electrician. All electrical wires and lines will need to be properly protected from outdoor elements.