Mental health patients having to travel as far as 79 miles for a bed is "not acceptable", says the charity Mind.