Would need a minimum water level of at least 6 inches and probably 12 would be better. I have it in a deep pot and am looking at some of the old copper pot copies in a smaller version which is about 12 to 18 inches. A shallow pot would limit considerably any plant choices and would work for small goldfish but not koi.
The manufacturer does not have a conversion kit in their catalog. The pump is AC, though small, probably would be hard pressed to be served by most typical solar kits for lights and such. You might call bamboo accents at (415) 454-6260 to ask their input.
I use mine outdoors, however I wouldn't hesitate to use it indoor if I hada place for it, it is very quiet. and soothing.
I got mine in Lancaster, PA long time on a plant store