Many people are being treated in places not designed for patients, the Royal College of Nursing says.