A new artwork has been unveiled in a hospital mental health unit.