who pays the last water bill after purchase?

Maybe. Your first call should be to the title company or attorney that handled your closing. In the DC, Maryland and Virginia metropolitan area, many title companies hold money in escrow from the seller to pay the final water bill.