Ex-Carlisle United striker Andy Preece has been appointed manager of National League strugglers Scunthorpe United.