If you want the fabric to stay soft, you might try fabric softener...it has a way of resisting other stains and seals in regular clothing and linens.
It you are planning on stretching the drop cloth to turn it into art, then any acrylic varnish will do.
It's usually best to use fabric paint on fabric, not acrylic.