Should my My Book for Mac always remain connected and on?

Probably, but most hard drives will go into sleep mode when they are not used.