Non-invertible symmetries and LSM-type constraints on a tensor product Hilbert space