Use the Q&A Thread.
You can't change the acceleration of a player agent. The best you can do is spawn an invisible scene prop behind the player (with a collision mesh) and animate it towards the body of water. Make sure to disable it when the player turns towards it.
As for your other thread, the same mechanism can be applied. You can only use agent_set_speed_limit on AI agents.