Emergent fractons and algebraic quantum liquid from plaquette melting transitions