Optimized decimation of tensor networks with super-orthogonalization for two-dimensional quantum lattice models