Mata Haggis will during this GDC talk tell you some practical tips about for creating a good story that will also help improve your game design.
Need to handle dialogue in Unity? I can recommend this tool. It is really comprehensive but it has a bit of a learning curve to it.
Need a system for Unreal then check out this free plugin that I think kicks all the competition so far.