The club’s Hollywood co-owners have brought a spotlight to north Wales but have made a difference to everyday lives