A new facility designed to offer support to adults experiencing a mental health crisis has officially opened its doors.