The most important thing with title sequences, and all text in your film, is clarity. Choose font and size that people will be able to read, usually going toward sans serif fonts that avoid extravagance. Make sure that the title itself takes prominence over the rest of the opening credits, possibly even changing its color or font.