A pet fountain assembly that includes a cover with a drinking bowl formed therein that straddles a sidewall of a basin that can be user-provided enclosing a pump within a pumping chamber defined therebetween. The cover has a downwardly extending sidewall divided by openings that can be generally U-shaped or V-shaped into a plurality of supports on which the cover. In a preferred embodiment, one of the supports is disposed outboard the basin sidewall resting on the ground and another one of the supports is disposed inboard the basin sidewall resting on a bottom of the basin providing a water passage enabling water from the basin to reach the pump. The inboard support can provide an overflow spillway as well as define a shroud disposed between the pump and water in a lower drinking bowl of the basin. The basin can include an outwardly offset seat that locates the pump.