Four Women's Championship teams will take part in a pilot scheme to allow fans to drink alcohol in the stands.