For a pixelated texture look. you simply need to switch from Bilinear/Trilinear Filtering to Nearest.
For Palette-like looks. You need a greyscale texture as your palette-index and a separate palette texture.
For the Palette-texture you can utilize Curve Atlases
