If you want to have the message displayed every time you open up a new terminal (under an X session), then `motd` is not the right place. It is executed by the `login` program - this happens when you log in on a real `tty` (or via `ssh` for example).
For terminal sessions, I believe the only universal way is to run `cat somefile` at the end of your shell's startup file: either personal (i.e. `~/.bashrc` `~/.zshrc` etc.) or global (under `/etc` \- see your shell's manpage for details). Generally, I'm afraid there isn't a "standard" way of doing this in case of terminal emulator sessions.