Drill a hole in bottom of the overflow to allow water to return via a bulkhead without any standpipe. A simple piece of PVC could be cut to "regulate" how much water depth you had in the tank itself. Then as Lhoy mentioned, push it over the overflow and allow it to fall back over rocks to create a water fall. It'd be simple enough to glue a patch over the overflow to return it to service as a tank.