The number of older people prescribed drugs that impact their mood and behaviour almost doubles when they move to care homes in the North, new research has indicated.